/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : 鲜大肉

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 10/04/2023 10:24:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
  `shop_id` int NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `type_id` int NOT NULL DEFAULT '9' COMMENT '分类id',
  `shop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
  `price` decimal(10,2) NOT NULL COMMENT '商品价格',
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品简介',
  `shop_pic` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品图片',
  `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '热卖' COMMENT '商品标签',
  `unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品单位',
  `stock` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '库存',
  `sale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '销量',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `hot` int DEFAULT '0' COMMENT '0：否，1：是',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shop
-- ----------------------------
BEGIN;
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (1, 1, '精品猪 精瘦肉', 18.80, '家常小炒、酥炸、烧炖', 'https://www.zsyyds.cn/Noerify/getImage?imgName=jingshourou.jpg', '热卖', '500克', '1000', '4203', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (2, 1, '精品猪 夹心肉', 15.80, '肉馅、肉丸子', 'https://www.zsyyds.cn/Noerify/getImage?imgName=jiaxinrou.jpg', '热卖', '500克', '1000', '1036', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (3, 1, '精品猪 带皮后腿肉', 13.80, '炒、炖、白切肉', 'https://www.zsyyds.cn/Noerify/getImage?imgName=daipihoutuirou.jpg', '热卖', '500克', '999', '5684', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (4, 2, '精品猪 五花肉', 15.80, '东坡肉、回锅肉、粉蒸肉', 'https://www.zsyyds.cn/Noerify/getImage?imgName=wuhuarou.jpg', '热卖', '500克', '1000', '5912', 'p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 1);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (5, 2, '精品猪 带骨五花肉', 88.80, '荷叶粉蒸肉', 'https://www.zsyyds.cn/Noerify/getImage?imgName=daiguwuhuarou.jpg', '热卖', '2000克', '1000', '4755', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (6, 3, '精品猪 前排', 13.80, '红烧排骨、糖醋排骨', 'https://www.zsyyds.cn/Noerify/getImage?imgName=qianpai.jpg', '热卖', '500克', '1000', '4211', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (7, 3, '精品猪 仔排', 23.80, '青椒仔排、蒜香陈皮骨', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zaipai.jpg', '热卖', '500克', '1000', '5224', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 1);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (8, 3, '精品猪 杂排', 13.80, '土豆炖杂排', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zapai.jpg', '热卖', '500克', '1000', '4468', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (9, 4, '精品猪 筒子骨一根', 14.80, '筒骨萝卜汤、筒骨炖土豆', 'https://www.zsyyds.cn/Noerify/getImage?imgName=tongzigu.jpg', '热卖', '1根', '999', '4613', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (10, 4, '精品猪 扇子骨一根', 15.80, '玉米扇骨汤、扇骨莲藕汤', 'https://www.zsyyds.cn/Noerify/getImage?imgName=shanzigu.jpg', '热卖', '1根', '999', '4079', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (11, 6, '精品猪 猪肘子（蹄髈）', 18.80, '红烧肘子、东坡肘子', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuzhou.jpg', '热卖', '1个', '1000', '3646', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (12, 6, '精品猪 猪脚', 20.80, '红烧猪蹄、黄豆焖猪蹄', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuti.jpg', '热卖', '1个', '1000', '5492', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (13, 7, '精品猪 大里脊', 22.80, '香煎猪里脊、油炸猪里脊', 'https://www.zsyyds.cn/Noerify/getImage?imgName=daliji.jpg', '热卖', '500克', '1000', '3267', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (14, 7, '精品猪 小里脊', 20.80, '酱香猪里脊、里脊炒时蔬', 'https://www.zsyyds.cn/Noerify/getImage?imgName=xiaoliji.jpg', '热卖', '500克', '1000', '3846', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (15, 7, '精品猪 带皮肥膘里脊肉', 13.80, '香煎里脊肉', 'https://www.zsyyds.cn/Noerify/getImage?imgName=daipilijirou.jpg', '热卖', '500克', '1000', '4337', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (16, 3, '精品猪 大排', 17.80, '香炸猪大排、红烧猪大排', 'https://www.zsyyds.cn/Noerify/getImage?imgName=dapai.jpg', '热卖', '500克', '1000', '5927', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (17, 8, '精品猪 猪心', 13.80, '猪心汤、爆炒猪心', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuxin.jpg', '热卖', '1个', '999', '3070', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (18, 8, '精品猪 猪腰', 22.80, '爆炒腰花、山药炒腰花', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuyao.jpg', '热卖', '500克', '1000', '4619', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (19, 8, '精品猪 猪肝', 16.80, '菠菜猪肝汤、爆炒猪肝、香卤猪肝', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhugan.jpg', '热卖', '500克', '1000', '4018', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (20, 8, '精品猪 猪舌', 29.80, '卤水猪舌、五香卤猪舌', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhushe.jpg', '热卖', '500克', '1000', '3744', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (21, 8, '精品猪 猪耳朵', 36.80, '黄瓜拌猪耳、酱烧猪耳', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuerduo.jpg', '热卖', '500克', '1000', '4758', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 1);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (22, 8, '精品猪 猪尾巴（长）', 22.80, '芸豆焖猪尾、红烧猪尾', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhuwei.jpg', '热卖', '500克', '999', '3636', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (23, 8, '精品猪 猪肚', 76.80, '胡椒猪肚鸡、猪肚包鸡', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhudu.jpg', '热卖', '800克-1000克', '1000', '4228', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (24, 8, '精品猪 猪大肠', 158.00, '尖椒肥肠、卤水肥肠', 'https://www.zsyyds.cn/Noerify/getImage?imgName=zhudachang.jpg', '热卖', '2000克', '1000', '4569', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 0);
INSERT INTO `shop` (`shop_id`, `type_id`, `shop_name`, `price`, `info`, `shop_pic`, `tag`, `unit`, `stock`, `sale`, `desc`, `hot`) VALUES (25, 8, '精品猪 肉沫（肥瘦2:8）', 11.80, '肉末茄子、肉沫粉条', 'https://www.zsyyds.cn/Noerify/getImage?imgName=roumo.jpg', '热卖', '500克', '1000', '4751', '<p>保质期 5天<p/><p>储存方法 0-3°C低温冷藏</p>', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
